package com.smit.livevideo.sample.db;

/**
 * Created by smfang on 2015/11/24. SQL执行语句
 */
public final class SmitSqls
{
    /**
     * sqls
     */
    public static final String DVB_CHANNEL_SQL = "Create table if not exists "
            + Tables.DVBChannel.DVB_CHANNEL_TABLE_NAME + "("
            + Tables.DVBChannel.DVB_CHANNEL_FIELD_ID + " integer primary key autoincrement,"
            + Tables.DVBChannel.DVB_CHANNEL_FIELD_INDEX + getInteger()
            + Tables.DVBChannel.DVB_CHANNEL_FIELD_CHANNELNAME
            + " text, " + Tables.DVBChannel.DVB_CHANNEL_FIELD_CHANNELNUMBER + getInteger()
            + Tables.DVBChannel.DVB_CHANNEL_FIELD_FREQ + getInteger()
            + Tables.DVBChannel.DVB_CHANNEL_FIELD_SYM
            + getInteger() + Tables.DVBChannel.DVB_CHANNEL_FIELD_MOD + " integer);";

    private SmitSqls()
    {

    }

    private static String getInteger()
    {
        return " integer, ";
    }
}
